You are here:

Decimal Format

This algorithm is used to format numbers under a specific column using a formatting pattern you specify yourself. The pattern is specified via the Format field.

Here are a few examples how the formatting can be applied:

Pattern	Source Number	Formatted Number
###.###	123.456	123.456
###.#	123.456	123.5
###,###.##	123456.789	123,456.79
000.###	9.95	009.95
##0.###	0.95	0.95

To configure this manipulate step, follow the instructions below:

In the Admin Navigation tree, select Interfaces > InterfaceName > Tasks > TaskName > Steps.
On the toolbar, click New >New Manipulate Step.

Creating a New Manipulate Step

Navigate to the Manipulate Columns section and select Decimal Format.

Manipulate Columns Section

In the Decimal Format work area, fill in the following fields:

Fields	Description
Name	Provide a distinctive name for this step.
Is Active	Select the check box to engage the scheduler for this step.
Order of Execution	Enter the order in which this step should be executed.
Filter Expression	Optional. Use this filed to filter data from the source database prior to inserting it into the Schema table.
Sort Expression	Optional. Use this field to sort data from the source database prior to inserting it into the Schema table.
Stop interface execution if query failed	Optional. If enabled, the system will stop any data manipulation if the query returns an error.
Save Schema (enabled per interface)	If selected, the schema is created for this step.
Source Column	Select the source column for data manipulation.
Format	Specify the pattern that determines what the formatted number looks like. You can use the following format specifiers when constructing a pattern: C (currency). Example: 123.456 => $123.46 P (percent). Example: 0.25 => 25.00% N (numeric). Example: 2500000 => 2,500,000.00 E (exponential). Example: 1052.0329112756 =>1.052033E+003 # (digit placeholder). Example: 45 => 0.## => 0.45
Target Column	Select the target column where the formatting will be applied.

Click the Save button.